2014-04-04 - 12276 - Spec - Inventory buckets #BExQueriesforCrystalReportsAnalysisTool

SPECIFICATIONS

12276 - Inventory Buckets

Purpose

Create buckets for Average Days Supply in the Inventory Analysis BEx Query.

Admin Info

Purpose	To create buckets in Inventory analysis BEx Query
Requested By	Mark Harris
Spec Created By	Chandramouli K
Spec Created Date	04/04/2014
Spec QA by	Uday Kumar P
Objects	ZDSOINVM_Q004, VIC_INVW_Q001.
Document Status	Complete

References

Prior Tickets

None

Documents

None

Functional Requirement

1. Need to create buckets for Average Days supply on inventory analysis BEx Query in BPD(BW 7.3 Development) as per NEC requirement.
2. Logic for calculation: Average Days Supply =
If Net available > 0 and (Quantity sold in last month) = 0 then 999 days.
Else
Net Available / (Quantity sold last month / Days in last period).
and
Net Available = Quantity on hand - Open Quantity current period.
3. Sort the days supply in 0-30, 31-60, 61-90 and >90 days bucket.
4. Need to Arrange the Characteristics and Variables in Alphabet Order and should not show decimals for Quantity Key Figures and suppress result rows for all characteristics.

Solution Summary

1. Need to create a BEx Query on Inventory Analysis in BPD(BW 7.3 Development).
2. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
3. Need to create & sort the Buckets in to 0-30 days, 31-60 days, 61-90 days, >90 days for Average Days Supply.
4. Need to check the BEx query for QA Standards.
5. Test and transport it to BPQ for detailed testing.

4. Need to Arrange the Characteristics and Variables in Alphabet Order and should not show decimals for Quantity Key Figures and suppress result rows for all characteristics.

Test Plan

SNo	Test Scenario	Expected Results
1	Check whether data is populating into the buckets as per the formulas defined.	Data should be populated successfully as per the formulas defined.
2	Check the Query against NEC standard BEx checklist.	Query should pass all test cases as per NEC checklist.
3	Check whether all the objects are collected into the transport request.	All the objects in the query should be collected into the transport request.
4	Check if alphabetical order is maintained and result rows suppressed.	Alphabetical Order is maintained and result rows are suppressed.

Solution Details

1. Need to create a BEx Query on Inventory Analysis in BPD(BW 7.3 Development) as per the naming conventions.
2. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
3. Need to create the formula for the Average Days Supply & Net available as the per functional requirement.
4. Need to create & sort the buckets in to 0-30 days, 31-60 days, 61-90 days, >90 days for Average Days Supply.
5. Need to check the BEx query for QA Standards and data in BPQ system.
6. Need to unit test the query and then transport it to BPQ(BW 7.3 Quality) for further testing.
7. Need to Arrange the Characteristics and Variables in Alphabet Order and should not show decimals for Quantity Key Figures and suppress result rows for all characteristics.

Issues

None